WIP/AR Summary

The WIP/AR Summary report summarizes the unbilled WIP and unapplied progress for each client. This report helps you determine the clients that you need to bill, and includes the date when each client was last billed.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

• Security group profile > Functional rights > Reports > Shared Library > Shared Views
• Security group profile > Functional rights > Reports > Firm Library > Custom
• Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
• Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
• Security group profile > Functional rights > Reports > Firm Library > <report name>
• Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Reports in Foundation that are Comparable

In Practice Management, the comparable report is WIP/AR Summary. In Practice Advantage, the comparable reports are WIP Summary Aging and AR Summary Aging.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option	Setting	Description
Select to Include Transactions Using…	List	Determines the date type to use for the date range on the report. The options are transaction date and accounting period date.
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.

Default Filters
Field Name	Operator	Value
Date	<=	Today

Optional Filters
Available Fields
AR Balance	Client Name	Manager
Business Code	Client Office	Primary Partner
Client	Client Primary Service Type	Progress Bills
Client – Principal	Client Region	Return Group
Client Bill Manager	Client Sub ID	Tax Type
Client Billing Group	Client Type	WIP Available
Client Business Unit	Date	WIP Remaining
Client ID	Financial Reporting Client Group
Client ID.Sub ID	Line of Business

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client ID.Sub ID	Financial Reporting Client Group
Client	Client Name	Line of Business
Client – Principal	Client Office	Manager
Client Bill Manager	Client Primary Service Type	Primary Partner
Client Billing Group	Client Region	Return Group
Client Business Unit	Client Sub ID	Sort Name
Client ID	Client Type	Tax Type

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Available Fields
Client ID	Client Name

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field	Description
Client ID	The client ID and sub-ID in Client ID.Sub-ID format.
Client Name	The client name.
WIP Available	The WIP available for billing.
Progress Bills	The total of unapplied progress bills.
WIP Remaining	The total amount of WIP available - Progress Bill amount.
AR Balance	The total AR balance for the client.
Last Invoice	The date of the last invoice for the client.

WIP/AR Summary Sample Report